<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta charset="UTF-8">
    <link rel="canonical" href="https://blog.csdn.net/sinat_36246371/article/details/72675736"/>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <meta name="renderer" content="webkit"/>
    <meta name="force-rendering" content="webkit"/>
    <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"/>
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="apple-mobile-web-app-status-bar-style" content="black">
    <meta name="report" content='{"pid":"blog"}'>
    <meta name="referrer" content="always">
    <meta http-equiv="Cache-Control" content="no-siteapp" /><link rel="alternate" media="handheld" href="#" />
    <meta name="shenma-site-verification" content="5a59773ab8077d4a62bf469ab966a63b_1497598848">
        <meta name="csdn-baidu-search"  content='{"autorun":true,"install":true,"keyword":"不登录到MySQL执行SQL语句 - K.Sun"}'>
    
    <link href="https://csdnimg.cn/public/favicon.ico" rel="SHORTCUT ICON">
    <title>不登录到MySQL执行SQL语句 - K.Sun - CSDN博客</title>

        
                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/detail-3c56c08d12.min.css">
            
        
            <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-2eefd34acf.min.css">
        <script type="text/javascript">
        var username = "sinat_36246371";
        var blog_address = "https://blog.csdn.net/sinat_36246371";
        var static_host = "https://csdnimg.cn/release/phoenix/";
        var currentUserName = "";
        var isShowAds = true;
        var isOwner = false;
        var loginUrl = "http://passport.csdn.net/account/login?from=https://blog.csdn.net/sinat_36246371/article/details/72675736"
        var blogUrl = "https://blog.csdn.net/";

        var curSkin = "skin-yellow";
        // 收藏所需数据
        var articleTitle = "不登录到MySQL执行SQL语句";
        var articleDesc = "一般来讲，我们在MySQL中执行查询都是进入到mysql中执行的，比如通过命令登录：$mysql-uroot-pEnterpassword:WelcometotheMySQLmonitor.Commandsendwith;or\\g.YourMySQLconnectionidis7Serverversion:5.7.17-0ubuntu0.16.";
        // 第四范式所需数据
        var articleTitles = "不登录到MySQL执行SQL语句 - K.Sun";
        
        var nickName = "K.Sun";
        var isCorporate = false;
        var subDomainBlogUrl = "https://blog.csdn.net/"
        var digg_base_url = "https://blog.csdn.net/sinat_36246371/phoenix/comment";
        var articleDetailUrl = "https://blog.csdn.net/sinat_36246371/article/details/72675736";
    </script>
    <script src="https://csdnimg.cn/public/common/libs/jquery/jquery-1.9.1.min.js" type="text/javascript"></script>
    <script src="//g.csdnimg.cn/??fixed-sidebar/1.1.3/fixed-sidebar.js,report/1.0.4/report.js" type="text/javascript"></script>
    <link rel="stylesheet" href="https://csdnimg.cn/public/sandalstrap/1.4/css/sandalstrap.min.css">
    <style>
        .MathJax, .MathJax_Message, .MathJax_Preview{
            display: none
        }
    </style>
</head>
<body class="nodata " > 
    <link rel="stylesheet" href="https://csdnimg.cn/public/common/toolbar/content_toolbar_css/content_toolbar.css">
    <script id="toolbar-tpl-scriptId" src="https://csdnimg.cn/public/common/toolbar/js/content_toolbar.js" type="text/javascript" domain="https://blog.csdn.net/"></script>
<div id="kp_box_476" data-pid="476" data-track-view='{"mod":"kp_popu_476-1490","con":",,"}' data-track-click='{"mod":"kp_popu_476-1490","con":",,"}' data-report-view='{"mod":"kp_popu_476-1490","keyword":""}' data-report-click='{"mod":"kp_popu_476-1490","keyword":""}'><script src="//csdnimg.cn/public/common/indexSuperise/1.1.1/indexSuperise.js?20190111165312"></script><script>window.csdn.indexSuperise({smallMoveImg:'https://img-bss.csdn.net/1565248701607.jpg',bigMoveImg:'https://img-bss.csdn.net/1565248693537.jpg',link:'https://kunyu.csdn.net?p=476&a=1490&c=652&k=&d=1&t=3&dest=https%3A%2F%2Fdeveloper.huaweicloud.com%2Fcompetition%2Fcompetitions%2F1000007620%2Fintroduction%3Futm_source%3Dcsdn%26utm_medium%3Dpr%26utm_campaign%3Dcsdntf%26utm_term%3Dgarbage',trackSuperId:476,smallMove:'notMove',trackSId:1490});</script></div><link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/blog_code-c3a0c33d5c.css">
<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-e040f0c7c8.css">

<script type="text/javascript">
	var NEWS_FEED = function(){}
</script>

<link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/chart-3456820cac.css" />
<div class="container clearfix" id="mainBox">
			<div class="recommend-right">
  <ul class="recommend-fixed-box">
    
  </ul>
</div>	    <main>
        <div class="blog-content-box">
    <div class="article-header-box">
        <div class="article-header">
            <div class="article-title-box">
                <span class="article-type type-1 float-left">原</span>                <h1 class="title-article">不登录到MySQL执行SQL语句</h1>
            </div>
            <div class="article-info-box">
                <div class="article-bar-top">
                                                                                                                                            <span class="time">2017年05月24日 14:00:15</span>
                    <a class="follow-nickName" href="https://me.csdn.net/sinat_36246371" target="_blank">K.Sun</a>
                    <span class="read-count">阅读数 7996</span>
                                                                                                                                </div>
                <div class="operating">
                                    </div>
            </div>
        </div>
    </div>
    <article class="baidu_pl">
                <div id="article_content" class="article_content clearfix">
                                                <div class="article-copyright">
                                                    <svg class="icon" title="CSDN认证原创" aria-hidden="true"
                                 style="width:53px; height: 18px; vertical-align: -4px;">
                                <use xlink:href="#CSDN_Cert"></use>
                            </svg>
                        
                        版权声明：本文为博主原创文章，未经博主允许不得转载。                        <a class="copy-right-url" href=" https://blog.csdn.net/sinat_36246371/article/details/72675736"> https://blog.csdn.net/sinat_36246371/article/details/72675736</a>
                    </div>
                                                    <link rel="stylesheet" href="https://csdnimg.cn/release/phoenix/template/css/ck_htmledit_views-3019150162.css" />
                                        <div id="content_views" class="markdown_views prism-atom-one-light">
                    <!-- flowchart 箭头图标 勿删 -->
                    <svg xmlns="http://www.w3.org/2000/svg" style="display: none;">
                        <path stroke-linecap="round" d="M5,0 0,2.5 5,5z" id="raphael-marker-block" style="-webkit-tap-highlight-color: rgba(0, 0, 0, 0);"></path>
                    </svg>
                                            <p>一般来讲，我们在MySQL中执行查询都是进入到mysql中执行的，比如通过命令登录：</p>



<pre class="prettyprint"><code class=" hljs applescript">$ mysql -u root -p
Enter password: 
Welcome <span class="hljs-keyword">to</span> <span class="hljs-keyword">the</span> MySQL monitor.  Commands <span class="hljs-keyword">end</span> <span class="hljs-keyword">with</span> ; <span class="hljs-keyword">or</span> \g.
Your MySQL connection <span class="hljs-property">id</span> <span class="hljs-keyword">is</span> <span class="hljs-number">7</span>
Server <span class="hljs-property">version</span>: <span class="hljs-number">5.7</span><span class="hljs-number">.17</span>-<span class="hljs-number">0</span>ubuntu0<span class="hljs-number">.16</span><span class="hljs-number">.04</span><span class="hljs-number">.1</span> (Ubuntu)

Copyright (c) <span class="hljs-number">2000</span>, <span class="hljs-number">2016</span>, Oracle <span class="hljs-keyword">and</span>/<span class="hljs-keyword">or</span> <span class="hljs-keyword">its</span> affiliates. All rights reserved.

Oracle <span class="hljs-keyword">is</span> a registered trademark <span class="hljs-keyword">of</span> Oracle Corporation <span class="hljs-keyword">and</span>/<span class="hljs-keyword">or</span> <span class="hljs-keyword">its</span>
affiliates. Other names may be trademarks <span class="hljs-keyword">of</span> their respective
owners.

Type 'help;' <span class="hljs-keyword">or</span> '\h' <span class="hljs-keyword">for</span> help. Type '\c' <span class="hljs-keyword">to</span> clear <span class="hljs-keyword">the</span> current input statement.

mysql&gt; 
</code></pre>

<p>然后再敲命令做查询，那么能不能直接就在终端或者命令行执行查询呢，答案是肯定的，只需要多加一个e参数即可：</p>



<pre class="prettyprint"><code class=" hljs asciidoc">$ mysql -u root -p -e "SHOW DATABASES"
<span class="hljs-header">Enter password: 
+--------------------+</span>
<span class="hljs-header">| Database           |
+--------------------+</span>
| information<span class="hljs-emphasis">_schema |
| mysql              |
| performance_</span>schema |
<span class="hljs-header">| sys                |
+--------------------+</span>
</code></pre>

<p>再做一个SELECT语句看看：</p>



<pre class="prettyprint"><code class=" hljs markdown">$ mysql -u root -p -e "SELECT * FROM user \G" mysql
Enter password: 
<span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">** 1. row **</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span>
<span class="hljs-code">                  Host: localhost</span>
<span class="hljs-code">                  User: root</span>
<span class="hljs-code">           Select_priv: Y</span>
<span class="hljs-code">           Insert_priv: Y</span>
<span class="hljs-code">           Update_priv: Y</span>
<span class="hljs-code">           Delete_priv: Y</span>
<span class="hljs-code">           Create_priv: Y</span>
<span class="hljs-code">             Drop_priv: Y</span>
<span class="hljs-code">           Reload_priv: Y</span>
<span class="hljs-code">         Shutdown_priv: Y</span>
<span class="hljs-code">          Process_priv: Y</span>
<span class="hljs-code">             File_priv: Y</span>
<span class="hljs-code">            Grant_priv: Y</span>
<span class="hljs-code">       References_priv: Y</span>
<span class="hljs-code">            Index_priv: Y</span>
<span class="hljs-code">            Alter_priv: Y</span>
<span class="hljs-code">          Show_db_priv: Y</span>
<span class="hljs-code">            Super_priv: Y</span>
 Create<span class="hljs-emphasis">_tmp_</span>table_priv: Y
<span class="hljs-code">      Lock_tables_priv: Y</span>
<span class="hljs-code">          Execute_priv: Y</span>
<span class="hljs-code">       Repl_slave_priv: Y</span>
<span class="hljs-code">      Repl_client_priv: Y</span>
<span class="hljs-code">      Create_view_priv: Y</span>
<span class="hljs-code">        Show_view_priv: Y</span>
   Create<span class="hljs-emphasis">_routine_</span>priv: Y
<span class="hljs-code">    Alter_routine_priv: Y</span>
<span class="hljs-code">      Create_user_priv: Y</span>
<span class="hljs-code">            Event_priv: Y</span>
<span class="hljs-code">          Trigger_priv: Y</span>
Create<span class="hljs-emphasis">_tablespace_</span>priv: Y
<span class="hljs-code">              ssl_type: </span>
<span class="hljs-code">            ssl_cipher: </span>
<span class="hljs-code">           x509_issuer: </span>
<span class="hljs-code">          x509_subject: </span>
<span class="hljs-code">         max_questions: 0</span>
<span class="hljs-code">           max_updates: 0</span>
<span class="hljs-code">       max_connections: 0</span>
  max<span class="hljs-emphasis">_user_</span>connections: 0
<span class="hljs-code">                plugin: mysql_native_password</span>
 authentication_string: *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9
<span class="hljs-code">      password_expired: N</span>
 password<span class="hljs-emphasis">_last_</span>changed: 2017-03-07 19:17:21
<span class="hljs-code">     password_lifetime: NULL</span>
<span class="hljs-code">        account_locked: N</span>
<span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">** 2. row **</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span><span class="hljs-strong">*****</span>
<span class="hljs-code">                  Host: localhost</span>
<span class="hljs-code">                  User: mysql.sys</span>
<span class="hljs-code">           Select_priv: N</span>
<span class="hljs-code">           Insert_priv: N</span>
<span class="hljs-code">           Update_priv: N</span>
<span class="hljs-code">           Delete_priv: N</span>

....................</code></pre>

<p>这样只不过是每次都得键入密码，有点繁琐，所以还是进入到MySQL再执行查询吧。</p>                                    </div>
                <link href="https://csdnimg.cn/release/phoenix/mdeditor/markdown_views-e44c3c0e64.css" rel="stylesheet">
                    </div>
    </article>
</div>

            <div class="hide-article-box hide-article-pos text-center">
            <a class="btn-readmore" data-report-view='{"mod":"popu_376","dest":"https://blog.csdn.net/sinat_36246371/article/details/72675736","strategy":"readmore"}' data-report-click='{"mod":"popu_376","dest":"https://blog.csdn.net/sinat_36246371/article/details/72675736","strategy":"readmore"}'>
                展开阅读全文
                <svg class="icon chevrondown" aria-hidden="true">
                    <use xlink:href="#csdnc-chevrondown"></use>
                </svg>
            </a>
        </div>
    
<script>
    $(".MathJax").remove();
    if ($('div.markdown_views pre.prettyprint code.hljs').length > 0) {
        $('div.markdown_views')[0].className = 'markdown_views';
    }
    var persentSet = 1;
</script>

<script src="https://csdnimg.cn/release/phoenix/vendor/linkCatcher/linkCatcher-3a08af3a5f.js"></script>        <div id="dmp_ad_58"><div id="kp_box_58" data-pid="58" data-track-view='{"mod":"kp_popu_58-386","con":",,"}' data-track-click='{"mod":"kp_popu_58-386","con":",,"}' data-report-view='{"mod":"kp_popu_58-386","keyword":""}' data-report-click='{"mod":"kp_popu_58-386","keyword":""}'><div style="width:100%;background:#fff;">
<script type="text/javascript" src="//rabc1.iteye.com/production/resource/web/6xwm4l.js?lg=ydmpioh"></script>
</div></div></div>        <a id="commentBox"></a>
<div class="comment-box">
	
	<div class="comment-edit-box d-flex">
		<a id="commentsedit"></a>
		<div class="user-img">
			<a href="javascript:void(0);" target="_blank">
				<img class="show_loginbox" src="//g.csdnimg.cn/static/user-img/anonymous-User-img.png">
			</a>
		</div>
		<form id="commentform">
			<input type="hidden" id="comment_replyId">
			<textarea class="comment-content" name="comment_content" id="comment_content" placeholder="想对作者说点什么"></textarea>
			<div class="opt-box"> <!-- d-flex -->
				<div id="ubbtools" class="add_code">
					<a href="#insertcode" code="code" target="_self"><i class="icon iconfont icon-daima"></i></a>
				</div>
				<input type="hidden" id="comment_replyId" name="comment_replyId">
				<input type="hidden" id="article_id" name="article_id" value="72675736">
				<input type="hidden" id="comment_userId" name="comment_userId" value="">
				<input type="hidden" id="commentId" name="commentId" value="">
				<div style="display: none;" class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_384","dest":""}'><a href="#" target="_blank" class="comment_area_btn">发表评论</a></div>
				<div class="dropdown" id="myDrap">
					<a class="dropdown-face d-flex align-items-center" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
					<div class="txt-selected text-truncate">添加代码片</div>
					<svg class="icon d-block" aria-hidden="true">
						<use xlink:href="#csdnc-triangledown"></use>
					</svg>
					</a>
					<ul class="dropdown-menu" id="commentCode" aria-labelledby="drop4">
						<li><a data-code="html">HTML/XML</a></li>
						<li><a data-code="objc">objective-c</a></li>
						<li><a data-code="ruby">Ruby</a></li>
						<li><a data-code="php">PHP</a></li>
						<li><a data-code="csharp">C</a></li>
						<li><a data-code="cpp">C++</a></li>
						<li><a data-code="javascript">JavaScript</a></li>
						<li><a data-code="python">Python</a></li>
						<li><a data-code="java">Java</a></li>
						<li><a data-code="css">CSS</a></li>
						<li><a data-code="sql">SQL</a></li>
						<li><a data-code="plain">其它</a></li>
					</ul>
				</div>  
				<div class="right-box">
					<span id="tip_comment" class="tip">还能输入<em>1000</em>个字符</span>
					<input type="button" class="btn btn-sm btn-cancel d-none" value="取消回复">
					<input type="submit" class="btn btn-sm btn-red btn-comment" value="发表评论">
				</div>
			</div>
		</form>
	</div>

		<div class="comment-list-container">
		<a id="comments"></a>
		<div class="comment-list-box">
		</div>
		<div id="commentPage" class="pagination-box d-none"></div>
		<div class="opt-box text-center">
			<div class="btn btn-sm btn-link-blue" id="btnMoreComment"></div>
		</div>
	</div>
</div>
        <div class="recommend-box">
                            <div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/long12310225/article/details/77521957","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/long12310225/article/details/77521957","strategy":"BlogCommendFromMachineLearnPai2","index":"0"}'>
	<div class="content">
		<a href="https://blog.csdn.net/long12310225/article/details/77521957" target="_blank" title="shell中执行mysql命令">
		<h4 class="text-truncate oneline">
				shell中<em>执行</em><em>mysql</em>命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-24</span>
				<span class="read-num hover-hide">
					阅读数 
					5172</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/long12310225/article/details/77521957" target="_blank" title="shell中执行mysql命令">
				<span class="desc oneline">今天折腾了一下午该死的mysql，果然还是经验欠缺，记录下错误，以便以后查看：一. 先整理下shell中执行mysql的几种方法吧：1. 使用-e进行参数传递，适合简单的命令，如mysql-uuser...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/long12310225">来自：	<span class="blog_title"> long12310225的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u011314442/article/details/79374344","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u011314442/article/details/79374344","strategy":"BlogCommendFromMachineLearnPai2","index":"1"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011314442/article/details/79374344" target="_blank" title="MySQL通过source命令执行sql文件">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>通过source命令<em>执行</em><em>sql</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-26</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011314442/article/details/79374344" target="_blank" title="MySQL通过source命令执行sql文件">
				<span class="desc oneline">见百度：https://jingyan.baidu.com/article/e75057f2e284ceebc91a891b.htmlIT人员经常会和MySQL打交道，备份和恢复应该是最常用的操作了，...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011314442">来自：	<span class="blog_title"> 愿我如星君如月 ... 夜夜流光相皎洁 ...</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010649766/article/details/78694318","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010649766/article/details/78694318","strategy":"BlogCommendFromMachineLearnPai2","index":"2"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010649766/article/details/78694318" target="_blank" title="不登陆数据库执行 MySQL 命令">
		<h4 class="text-truncate oneline">
				不登陆数据库<em>执行</em> <em>MySQL</em> 命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-02</span>
				<span class="read-num hover-hide">
					阅读数 
					2053</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010649766/article/details/78694318" target="_blank" title="不登陆数据库执行 MySQL 命令">
				<span class="desc oneline">不登陆数据库执行MySQL命令有的时候需要查看数据库的某些信息，然后继续接下来的shell命令操作，登录数据库在退出嫌麻烦可以使用这招：例1：列出所有数据库mysql-hhost_name-P3306...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010649766">来自：	<span class="blog_title"> 独一无二的小个性</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/czbqoo01/article/details/70037987","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/czbqoo01/article/details/70037987","strategy":"BlogCommendFromMachineLearnPai2","index":"3"}'>
	<div class="content">
		<a href="https://blog.csdn.net/czbqoo01/article/details/70037987" target="_blank" title="MySQL执行外部sql脚本文件的命令">
		<h4 class="text-truncate oneline">
				<em>MySQL</em><em>执行</em>外部<em>sql</em>脚本文件的命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-10</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/czbqoo01/article/details/70037987" target="_blank" title="MySQL执行外部sql脚本文件的命令">
				<span class="desc oneline">MySQL执行外部sql脚本文件的命令sql脚本是包含一到多个sql命令的sql语句，我们可以将这些sql脚本放在一个文本文件中（我们称之为“sql脚本文件”），然后通过相关的命令执行这个sql脚本文...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/czbqoo01">来自：	<span class="blog_title"> ReaderWriter的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_59" data-pid="59" data-track-view='{"mod":"kp_popu_59-860","con":",,SQL"}' data-track-click='{"mod":"kp_popu_59-860","con":",,SQL"}' data-report-view='{"mod":"kp_popu_59-860","keyword":"SQL"}' data-report-click='{"mod":"kp_popu_59-860","keyword":"SQL"}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/109?positionId=59&queryWord=SQL" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/gzh0222/article/details/7961230","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/gzh0222/article/details/7961230","strategy":"BlogCommendFromMachineLearnPai2","index":"4"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gzh0222/article/details/7961230" target="_blank" title="shell中操作mysql数据库">
		<h4 class="text-truncate oneline">
				shell中操作<em>mysql</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-09</span>
				<span class="read-num hover-hide">
					阅读数 
					2699</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gzh0222/article/details/7961230" target="_blank" title="shell中操作mysql数据库">
				<span class="desc oneline">mysql -hhostname-Pport-uusername-ppassword -e 相关mysql的sql语句，不用在mysql的提示符下运行mysql，即可以在shell中操作mysql的方...</span>
			</a>
			<span class="blog_title_box oneline no-title">
									<span class="type-show type-show-blog type-show-after">博文</span>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u012026446/article/details/81094027","strategy":"BlogCommendFromBaidu","index":"5"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u012026446/article/details/81094027","strategy":"BlogCommendFromBaidu","index":"5"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012026446/article/details/81094027" target="_blank" title="mysql数据库中-e是什么意思？-e参数使用详解">
		<h4 class="text-truncate oneline">
				<em>mysql</em>数据库中-e是什么意思？-e参数使用详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-18</span>
				<span class="read-num hover-hide">
					阅读数 
					9023</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012026446/article/details/81094027" target="_blank" title="mysql数据库中-e是什么意思？-e参数使用详解">
				<span class="desc oneline">可以用shell脚本操作mysql数据库，使用mysql的-e参数可以执行各种sql的(创建，删除，增，删，改、查)等各种操作。用法mysql-hhostname-Pport-uusername-pp...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012026446">来自：	<span class="blog_title"> u012026446的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/kimqcn4/article/details/81869914","strategy":"BlogCommendFromBaidu","index":"6"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/kimqcn4/article/details/81869914","strategy":"BlogCommendFromBaidu","index":"6"}'>
	<div class="content">
		<a href="https://blog.csdn.net/kimqcn4/article/details/81869914" target="_blank" title="MySQL: 利用Mysql的-e参数实现.bat脚本下快速重建数据库和用户.">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>: 利用<em>Mysql</em>的-e参数实现.bat脚本下快速重建数据库和用户.		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-20</span>
				<span class="read-num hover-hide">
					阅读数 
					1186</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/kimqcn4/article/details/81869914" target="_blank" title="MySQL: 利用Mysql的-e参数实现.bat脚本下快速重建数据库和用户.">
				<span class="desc oneline">在做软件自动化测试时,会有清空数据库重新初始化系统的情况.如果业务系统本身不支持清库操作,我们可以自己实现.利用Mysql的-e参数实现.bat脚本下快速重建数据库和用户.-e,--execute=n...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/kimqcn4">来自：	<span class="blog_title"> 七侠镇莫小贝的同福客栈</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/c1052981766/article/details/80265591","strategy":"BlogCommendFromBaidu","index":"7"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/c1052981766/article/details/80265591","strategy":"BlogCommendFromBaidu","index":"7"}'>
	<div class="content">
		<a href="https://blog.csdn.net/c1052981766/article/details/80265591" target="_blank" title="mysql将输出结果到文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>将输出结果到文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">05-10</span>
				<span class="read-num hover-hide">
					阅读数 
					448</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/c1052981766/article/details/80265591" target="_blank" title="mysql将输出结果到文件">
				<span class="desc oneline">1.sql:selecta,date_format(b,&amp;quot;%Y-%m&amp;quot;)fromtgroupbya,date_format(b,&amp;quot;%Y-%m&amp;quot;)intooutf...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/c1052981766">来自：	<span class="blog_title"> c1052981766的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/e12489/article/details/89705529","strategy":"BlogCommendFromBaidu","index":"8"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/e12489/article/details/89705529","strategy":"BlogCommendFromBaidu","index":"8"}'>
	<div class="content">
		<a href="https://blog.csdn.net/e12489/article/details/89705529" target="_blank" title="mysql">
		<h4 class="text-truncate oneline">
				<em>mysql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-30</span>
				<span class="read-num hover-hide">
					阅读数 
					47</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/e12489/article/details/89705529" target="_blank" title="mysql">
				<span class="desc oneline">读写锁也叫排他所和共享锁的特点，读写锁的优先级锁粒度锁力度精确锁定两个层面管理锁，存储引擎和mysql服务器事务的概念和特性，就是一组原子性的sql查询事务的隔离级别，读未提交，读已提交，可重复读，序...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/e12489">来自：	<span class="blog_title"> e12489的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_60" data-pid="60" data-track-view='{"mod":"kp_popu_60-43","con":",,"}' data-track-click='{"mod":"kp_popu_60-43","con":",,"}' data-report-view='{"mod":"kp_popu_60-43","keyword":""}' data-report-click='{"mod":"kp_popu_60-43","keyword":""}'><div id="three_ad8" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad8",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/lovequanquqn/article/details/84728886","strategy":"BlogCommendFromBaidu","index":"9"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/lovequanquqn/article/details/84728886","strategy":"BlogCommendFromBaidu","index":"9"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lovequanquqn/article/details/84728886" target="_blank" title="docker 启动mysql以及问题 -e MYSQL_ROOT_PASSWORD">
		<h4 class="text-truncate oneline">
				docker 启动<em>mysql</em>以及问题 -e <em>MYSQL</em>_ROOT_PASSWORD		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-02</span>
				<span class="read-num hover-hide">
					阅读数 
					1768</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lovequanquqn/article/details/84728886" target="_blank" title="docker 启动mysql以及问题 -e MYSQL_ROOT_PASSWORD">
				<span class="desc oneline">dockerrun-p3308:3308--name=mysql-eMYSQL_ROOT_PASSWORD=123456mysql:5.6Initializingdatabase[root@local...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lovequanquqn">来自：	<span class="blog_title"> 进修的CODER</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/haitianweijing/article/details/79917548","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/haitianweijing/article/details/79917548","strategy":"BlogCommendFromMachineLearnPai2","index":"10"}'>
	<div class="content">
		<a href="https://blog.csdn.net/haitianweijing/article/details/79917548" target="_blank" title="MYSQL命令行远程登录及脚本执行">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>命令行远程登录及脚本<em>执行</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-12</span>
				<span class="read-num hover-hide">
					阅读数 
					1638</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/haitianweijing/article/details/79917548" target="_blank" title="MYSQL命令行远程登录及脚本执行">
				<span class="desc oneline">一、mysql配置环境变量后，cdm打开windows命令行进行远程登录：远程登录命令：mysql-hip地址-uroot-P端口号-p；-h后跟远程登录的IP地址-P后是数据库的端口号-u后是远程登...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/haitianweijing">来自：	<span class="blog_title"> 海天味精7的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
			<div class="recommend-item-box blog-expert-recommend-box">
			<div class="d-flex">
				<div class="blog-expert-recommend">
					<div class="blog-expert">
						<div class="blog-expert-flexbox"></div>
					</div>
				</div>
			</div>
		</div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qidaif/article/details/80931703","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qidaif/article/details/80931703","strategy":"BlogCommendFromMachineLearnPai2","index":"11"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qidaif/article/details/80931703" target="_blank" title="MySQL查看实时执行的SQL语句">
		<h4 class="text-truncate oneline">
				<em>MySQL</em>查看实时<em>执行</em>的<em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">07-05</span>
				<span class="read-num hover-hide">
					阅读数 
					8095</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qidaif/article/details/80931703" target="_blank" title="MySQL查看实时执行的SQL语句">
				<span class="desc oneline">MySQL默认不能实时查看执行的SQL语句，因为这会消耗一定的资源。要开启这个功能，稍微配置一下，打开这个LOG记录就可以了。1查看LOG功能首先，查看是否已经开启实时SQL语句记录。mysql&amp;am...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qidaif">来自：	<span class="blog_title"> qidaif的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sunqingzhong44/article/details/70569954","strategy":"BlogCommendFromBaidu","index":"12"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sunqingzhong44/article/details/70569954","strategy":"BlogCommendFromBaidu","index":"12"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sunqingzhong44/article/details/70569954" target="_blank" title="mysql优化——mysql -e命令详解">
		<h4 class="text-truncate oneline">
				<em>mysql</em>优化——<em>mysql</em> -e命令详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-24</span>
				<span class="read-num hover-hide">
					阅读数 
					387</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sunqingzhong44/article/details/70569954" target="_blank" title="mysql优化——mysql -e命令详解">
				<span class="desc oneline">使用mysql的-e参数可以执行各种sql的(创建，删除，增，删，改、查)等各种操作，可以用shell脚本操作MySQL数据库mysql -hhostname-Pport-uusername-ppas...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sunqingzhong44">来自：	<span class="blog_title"> 路漫漫其修远兮，吾将上下而求索。</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaoxinghehe/article/details/8663085","strategy":"BlogCommendFromBaidu","index":"13"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xiaoxinghehe/article/details/8663085","strategy":"BlogCommendFromBaidu","index":"13"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xiaoxinghehe/article/details/8663085" target="_blank" title="shell脚本操作mysql数据库">
		<h4 class="text-truncate oneline">
				shell脚本操作<em>mysql</em>数据库		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-12</span>
				<span class="read-num hover-hide">
					阅读数 
					5790</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xiaoxinghehe/article/details/8663085" target="_blank" title="shell脚本操作mysql数据库">
				<span class="desc oneline">mysql -hhostname-Pport-uusername-ppassword -e 相关mysql的sql语句，不用在mysql的提示符下运行mysql，即可以在shell中操作mysql的方...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xiaoxinghehe">来自：	<span class="blog_title"> 小兴的学习笔记</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_61" data-pid="61" data-track-view='{"mod":"kp_popu_61-557","con":",,"}' data-track-click='{"mod":"kp_popu_61-557","con":",,"}' data-report-view='{"mod":"kp_popu_61-557","keyword":""}' data-report-click='{"mod":"kp_popu_61-557","keyword":""}'><div id="three_ad13" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'GNKXx7',
                placeholderId: "three_ad13",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u010359663/article/details/84815947","strategy":"BlogCommendFromBaidu","index":"14"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u010359663/article/details/84815947","strategy":"BlogCommendFromBaidu","index":"14"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u010359663/article/details/84815947" target="_blank" title="批处理模式下使用MYSQL mysql -e">
		<h4 class="text-truncate oneline">
				批处理模式下使用<em>MYSQL</em> <em>mysql</em> -e		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					123</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u010359663/article/details/84815947" target="_blank" title="批处理模式下使用MYSQL mysql -e">
				<span class="desc oneline">http://blog.csdn.net/peopleqinlei/article/details/50978474 mysql-e&amp;quot;sourcebatch-file&amp;quot;mysql-...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u010359663">来自：	<span class="blog_title"> 痴迷无限好</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/fdipzone/article/details/78660204","strategy":"BlogCommendFromBaidu","index":"15"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/fdipzone/article/details/78660204","strategy":"BlogCommendFromBaidu","index":"15"}'>
	<div class="content">
		<a href="https://blog.csdn.net/fdipzone/article/details/78660204" target="_blank" title="mysql在终端执行sql并把结果写入文件的方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>在终端<em>执行</em><em>sql</em>并把结果写入文件的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-28</span>
				<span class="read-num hover-hide">
					阅读数 
					2万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/fdipzone/article/details/78660204" target="_blank" title="mysql在终端执行sql并把结果写入文件的方法">
				<span class="desc oneline">本文介绍使用mysql，直接在终端执行sql语句，并把执行后的结果保存到文件的方法。提供完成演示代码及实例。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/fdipzone">来自：	<span class="blog_title"> 傲雪星枫</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/gb4215287/article/details/51636698","strategy":"BlogCommendFromBaidu","index":"16"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/gb4215287/article/details/51636698","strategy":"BlogCommendFromBaidu","index":"16"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gb4215287/article/details/51636698" target="_blank" title="mysql免密码登录, 及使用-e 参数执行sql脚本">
		<h4 class="text-truncate oneline">
				<em>mysql</em>免密码登录, 及使用-e 参数<em>执行</em><em>sql</em>脚本		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-11</span>
				<span class="read-num hover-hide">
					阅读数 
					6427</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gb4215287/article/details/51636698" target="_blank" title="mysql免密码登录, 及使用-e 参数执行sql脚本">
				<span class="desc oneline">来源:http://www.tuicool.com/articles/7JbmYr我们在编写shell脚本的时候,经常需要和mysql交互.如果是交互环境,可能使用这样的命令登录到mysql#mysq...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gb4215287">来自：	<span class="blog_title"> gb4215287的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/skydreamer01/article/details/3900655","strategy":"BlogCommendFromBaidu","index":"17"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/skydreamer01/article/details/3900655","strategy":"BlogCommendFromBaidu","index":"17"}'>
	<div class="content">
		<a href="https://blog.csdn.net/skydreamer01/article/details/3900655" target="_blank" title="mysql中不输出表头和结尾的方法">
		<h4 class="text-truncate oneline">
				<em>mysql</em>中不输出表头和结尾的方法		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-17</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/skydreamer01/article/details/3900655" target="_blank" title="mysql中不输出表头和结尾的方法">
				<span class="desc oneline">当想使用数据库中的某些数据，想将其导入到文件中。这时一般用如下命令：echo&quot;selectvername,funveridfromfunshion_version&quot;|mysqllabindw&gt;funs...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/skydreamer01">来自：	<span class="blog_title"> 老好人(廖海仁）的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/gb4215287/article/details/51636692","strategy":"BlogCommendFromBaidu","index":"18"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/gb4215287/article/details/51636692","strategy":"BlogCommendFromBaidu","index":"18"}'>
	<div class="content">
		<a href="https://blog.csdn.net/gb4215287/article/details/51636692" target="_blank" title="mysql -uroot -proot tc -e &quot;select * from merchandise limit 1&quot;这个-E的命令作用是什么，用来什么什么的？">
		<h4 class="text-truncate oneline">
				<em>mysql</em> -uroot -proot tc -e &quot;select * from merchandise limit 1&quot;这个-E的命令作用是什么，用来什么什么的？		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-11</span>
				<span class="read-num hover-hide">
					阅读数 
					2396</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/gb4215287/article/details/51636692" target="_blank" title="mysql -uroot -proot tc -e &quot;select * from merchandise limit 1&quot;这个-E的命令作用是什么，用来什么什么的？">
				<span class="desc oneline">来源:http://bbs.csdn.net/topics/390450445?page=1-e, --execute=name  Execute command and quit. (Disable...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/gb4215287">来自：	<span class="blog_title"> gb4215287的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_62" data-pid="62" data-track-view='{"mod":"kp_popu_62-1062","con":",,"}' data-track-click='{"mod":"kp_popu_62-1062","con":",,"}' data-report-view='{"mod":"kp_popu_62-1062","keyword":""}' data-report-click='{"mod":"kp_popu_62-1062","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/237?positionId=62&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_33997121/article/details/83689068","strategy":"BlogCommendFromBaidu","index":"19"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_33997121/article/details/83689068","strategy":"BlogCommendFromBaidu","index":"19"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_33997121/article/details/83689068" target="_blank" title="Docker设置Mysql密码&amp;&amp;启动">
		<h4 class="text-truncate oneline">
				Docker设置<em>Mysql</em>密码&amp;&amp;启动		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-03</span>
				<span class="read-num hover-hide">
					阅读数 
					5193</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_33997121/article/details/83689068" target="_blank" title="Docker设置Mysql密码&amp;&amp;启动">
				<span class="desc oneline">	使用mysql镜像	 runoob@runoob:~/mysql$dockerrun-p3306:3306--namemymysql-v$PWD/conf:/etc/mysql/conf.d-v$P...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_33997121">来自：	<span class="blog_title"> qq_33997121的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u012498660/article/details/51097192","strategy":"BlogCommendFromBaidu","index":"20"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u012498660/article/details/51097192","strategy":"BlogCommendFromBaidu","index":"20"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012498660/article/details/51097192" target="_blank" title="MYSQL之N参数和e参数之命令行执行sql语句">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>之N参数和e参数之命令行<em>执行</em><em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-08</span>
				<span class="read-num hover-hide">
					阅读数 
					1593</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012498660/article/details/51097192" target="_blank" title="MYSQL之N参数和e参数之命令行执行sql语句">
				<span class="desc oneline">在命令行如果想直接执行sql语句，可以直接利用e参数，如果不想显示列名可以使用N参数-N 代表不显示列名-e statement  执行statement通用格式：mysql-u帐号-p密码 -N-e...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012498660">来自：	<span class="blog_title"> u012498660的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/bks429/article/details/78331690","strategy":"BlogCommendFromBaidu","index":"21"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/bks429/article/details/78331690","strategy":"BlogCommendFromBaidu","index":"21"}'>
	<div class="content">
		<a href="https://blog.csdn.net/bks429/article/details/78331690" target="_blank" title="linux mysql：command not find,mysql -e 导出文件">
		<h4 class="text-truncate oneline">
				linux <em>mysql</em>：command not find,<em>mysql</em> -e 导出文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-24</span>
				<span class="read-num hover-hide">
					阅读数 
					583</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/bks429/article/details/78331690" target="_blank" title="linux mysql：command not find,mysql -e 导出文件">
				<span class="desc oneline">ln-s/usr/local/mysql/bin/mysql/usr/bin　做个链接即可mysql-uroot-pathena-e“selectteacher_code,contentfromhom...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/bks429">来自：	<span class="blog_title"> 一刻不停</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/xuanxuan_good/article/details/53671258","strategy":"BlogCommendFromBaidu","index":"22"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/xuanxuan_good/article/details/53671258","strategy":"BlogCommendFromBaidu","index":"22"}'>
	<div class="content">
		<a href="https://blog.csdn.net/xuanxuan_good/article/details/53671258" target="_blank" title="mysql 三种灾备方式">
		<h4 class="text-truncate oneline">
				<em>mysql</em> 三种灾备方式		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-15</span>
				<span class="read-num hover-hide">
					阅读数 
					5745</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/xuanxuan_good/article/details/53671258" target="_blank" title="mysql 三种灾备方式">
				<span class="desc oneline">转自： http://tchuairen.blog.51cto.com/3848118/1432606/ 目标：1.使用mysqldump实现从逻辑角度完全备份mysql，配合二进制日志备份实现增量备...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/xuanxuan_good">来自：	<span class="blog_title"> cocoyan 的技术博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/CleverCode/article/details/50177975","strategy":"BlogCommendFromBaidu","index":"23"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/CleverCode/article/details/50177975","strategy":"BlogCommendFromBaidu","index":"23"}'>
	<div class="content">
		<a href="https://blog.csdn.net/CleverCode/article/details/50177975" target="_blank" title="mysql -e与awk联合导出csv文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em> -e与awk联合导出csv文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-04</span>
				<span class="read-num hover-hide">
					阅读数 
					2982</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/CleverCode/article/details/50177975" target="_blank" title="mysql -e与awk联合导出csv文件">
				<span class="desc oneline">CleverCode发现一个导出mysql数据成csv格式的简单方法。1）mysql-e使用简介使用说明：执行一个sql语句并且退出。格式样例：1)mysql-uroot-p123456-h192.1...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/CleverCode">来自：	<span class="blog_title"> CleverCode的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_63" data-pid="63" data-track-view='{"mod":"kp_popu_63-1059","con":",,"}' data-track-click='{"mod":"kp_popu_63-1059","con":",,"}' data-report-view='{"mod":"kp_popu_63-1059","keyword":""}' data-report-click='{"mod":"kp_popu_63-1059","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/234?positionId=63&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u011630575/article/details/52143600","strategy":"BlogCommendFromBaidu","index":"24"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u011630575/article/details/52143600","strategy":"BlogCommendFromBaidu","index":"24"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u011630575/article/details/52143600" target="_blank" title="shell脚本操作mysql数据库，使用mysql的-e参数可以执行各种sql的(创建，删除，增，删，改、查)等各种操作">
		<h4 class="text-truncate oneline">
				shell脚本操作<em>mysql</em>数据库，使用<em>mysql</em>的-e参数可以<em>执行</em>各种<em>sql</em>的(创建，删除，增，删，改、查)等各种操作		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-07</span>
				<span class="read-num hover-hide">
					阅读数 
					861</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u011630575/article/details/52143600" target="_blank" title="shell脚本操作mysql数据库，使用mysql的-e参数可以执行各种sql的(创建，删除，增，删，改、查)等各种操作">
				<span class="desc oneline">mysql -hhostname-Pport-uusername-ppassword -e 相关mysql的sql语句，不用在mysql的提示符下运行mysql，即可以在shell中操作mysql的方...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u011630575">来自：	<span class="blog_title"> 飘过的春风</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wusuopuBUPT/article/details/43952921","strategy":"BlogCommendFromBaidu","index":"25"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wusuopuBUPT/article/details/43952921","strategy":"BlogCommendFromBaidu","index":"25"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wusuopuBUPT/article/details/43952921" target="_blank" title="【MySQL】命令行执行sql，去除字段名">
		<h4 class="text-truncate oneline">
				【<em>MySQL</em>】命令行<em>执行</em><em>sql</em>，去除字段名		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-26</span>
				<span class="read-num hover-hide">
					阅读数 
					3041</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wusuopuBUPT/article/details/43952921" target="_blank" title="【MySQL】命令行执行sql，去除字段名">
				<span class="desc oneline">mysql的-e选项可以让我们在命令行下执行sql:/bin/mysql-hlocalhost-u{user_name}-p{password}-P3308{db_name}-e&quot;selectidfr...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wusuopuBUPT">来自：	<span class="blog_title"> wusuopuBUPT的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sd4015700/article/details/50516876","strategy":"BlogCommendFromBaidu","index":"26"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sd4015700/article/details/50516876","strategy":"BlogCommendFromBaidu","index":"26"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sd4015700/article/details/50516876" target="_blank" title="shell脚本连接、读写、操作mysql数据库实例">
		<h4 class="text-truncate oneline">
				shell脚本连接、读写、操作<em>mysql</em>数据库实例		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-14</span>
				<span class="read-num hover-hide">
					阅读数 
					529</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sd4015700/article/details/50516876" target="_blank" title="shell脚本连接、读写、操作mysql数据库实例">
				<span class="desc oneline">本文介绍了如何在shell中读写mysql数据库。主要介绍了如何在shell中连接mysql数据库，如何在shell中创建数据库，创建表，插入csv文件，读取mysql数据库，导出mysql数据库为x...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sd4015700">来自：	<span class="blog_title"> sd4015700的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq302501035/article/details/41966037","strategy":"BlogCommendFromBaidu","index":"27"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq302501035/article/details/41966037","strategy":"BlogCommendFromBaidu","index":"27"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq302501035/article/details/41966037" target="_blank" title="mysql命令参数详解">
		<h4 class="text-truncate oneline">
				<em>mysql</em>命令参数详解		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-16</span>
				<span class="read-num hover-hide">
					阅读数 
					5907</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq302501035/article/details/41966037" target="_blank" title="mysql命令参数详解">
				<span class="desc oneline">一，mysql命令行参数Usage:mysql[OPTIONS][database]//命令方式-?,--help//显示帮助信息并退出-I,--help//显示帮助信息并退出--auto-rehas...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq302501035">来自：	<span class="blog_title"> super_bert的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/lovelovelovelovelo/article/details/68957162","strategy":"BlogCommendFromBaidu","index":"28"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/lovelovelovelovelo/article/details/68957162","strategy":"BlogCommendFromBaidu","index":"28"}'>
	<div class="content">
		<a href="https://blog.csdn.net/lovelovelovelovelo/article/details/68957162" target="_blank" title="直接通过mysql命令运行sql脚本">
		<h4 class="text-truncate oneline">
				直接通过<em>mysql</em>命令运行<em>sql</em>脚本		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-03</span>
				<span class="read-num hover-hide">
					阅读数 
					3511</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/lovelovelovelovelo/article/details/68957162" target="_blank" title="直接通过mysql命令运行sql脚本">
				<span class="desc oneline">未登录mysqlmysql-uroot-p123456--port3306</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/lovelovelovelovelo">来自：	<span class="blog_title"> CherishL_的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_64" data-pid="64" data-track-view='{"mod":"kp_popu_64-81","con":",,"}' data-track-click='{"mod":"kp_popu_64-81","con":",,"}' data-report-view='{"mod":"kp_popu_64-81","keyword":""}' data-report-click='{"mod":"kp_popu_64-81","keyword":""}'><div id="three_ad28" class="mediav_ad" ></div>
<script type="text/javascript" src="//static.mediav.com/js/mvf_news_feed.js"></script>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad28",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zztiandaochouqin/article/details/84129677","strategy":"BlogCommendFromBaidu","index":"29"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zztiandaochouqin/article/details/84129677","strategy":"BlogCommendFromBaidu","index":"29"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zztiandaochouqin/article/details/84129677" target="_blank" title="mysql的source导入乱码解决方案">
		<h4 class="text-truncate oneline">
				<em>mysql</em>的source导入乱码解决方案		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-17</span>
				<span class="read-num hover-hide">
					阅读数 
					22</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zztiandaochouqin/article/details/84129677" target="_blank" title="mysql的source导入乱码解决方案">
				<span class="desc oneline">1，数据库备份命令（注意：要在cmd界面下先进入mysqldump的目录下才能使用mysqldump）mysqldump-uroot-p--default-character-set=gbkdbnam...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zztiandaochouqin">来自：	<span class="blog_title"> 学无先后,达者为先</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"http://ask.csdn.net/questions/648026","strategy":"BlogCommendFromBaidu","index":"30"}' data-report-click='{"mod":"popu_614","dest":"http://ask.csdn.net/questions/648026","strategy":"BlogCommendFromBaidu","index":"30"}'>
	<a href="http://ask.csdn.net/questions/648026" target="_blank">
		<h4 class="text-truncate oneline">
				<em>MySql</em>查询连续登陆天数		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">08-07</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">-</span>
							<span class="type-show type-show-ask">问答</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/phoebird/article/details/2797961","strategy":"BlogCommendFromBaidu","index":"31"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/phoebird/article/details/2797961","strategy":"BlogCommendFromBaidu","index":"31"}'>
	<div class="content">
		<a href="https://blog.csdn.net/phoebird/article/details/2797961" target="_blank" title="mysql命令行命令和SQL语句 ">
		<h4 class="text-truncate oneline">
				<em>mysql</em>命令行命令和<em>SQL</em><em>语句</em> 		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-19</span>
				<span class="read-num hover-hide">
					阅读数 
					7460</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/phoebird/article/details/2797961" target="_blank" title="mysql命令行命令和SQL语句 ">
				<span class="desc oneline"> 一 .常用mysql命令行命令      1.启动MYSQL服务  netstartmysql停止MYSQL服务  netstopmysql       2.netstat–na|findstr33...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/phoebird">来自：	<span class="blog_title"> 幽狼</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34081595/article/details/85828373","strategy":"BlogCommendFromBaidu","index":"32"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_34081595/article/details/85828373","strategy":"BlogCommendFromBaidu","index":"32"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_34081595/article/details/85828373" target="_blank" title="在mysql命令行下执行sql文件">
		<h4 class="text-truncate oneline">
				在<em>mysql</em>命令行下<em>执行</em><em>sql</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">11-02</span>
				<span class="read-num hover-hide">
					阅读数 
					12</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_34081595/article/details/85828373" target="_blank" title="在mysql命令行下执行sql文件">
				<span class="desc oneline">***********在mysql命令行下执行sql文件***********C:\Windows\system32&amp;amp;gt;cdE:\MySQL\mysql-5.7.16-winx64\bin...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_34081595">来自：	<span class="blog_title"> weixin_34081595的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/wrh_csdn/article/details/79424955","strategy":"BlogCommendFromBaidu","index":"33"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/wrh_csdn/article/details/79424955","strategy":"BlogCommendFromBaidu","index":"33"}'>
	<div class="content">
		<a href="https://blog.csdn.net/wrh_csdn/article/details/79424955" target="_blank" title="如何用命令行执行mysql的sql文件">
		<h4 class="text-truncate oneline">
				如何用命令行<em>执行</em><em>mysql</em>的<em>sql</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">03-02</span>
				<span class="read-num hover-hide">
					阅读数 
					2045</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/wrh_csdn/article/details/79424955" target="_blank" title="如何用命令行执行mysql的sql文件">
				<span class="desc oneline">使用source命令执行sql脚本。进入mysql的控制台后，使用source命令执行Mysql&amp;amp;gt;source【sql脚本文件的路径全名】具体步骤：假设运行sql脚本是hello.sql...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/wrh_csdn">来自：	<span class="blog_title"> wrh_csdn的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_65" data-pid="65" data-track-view='{"mod":"kp_popu_65-1061","con":",,"}' data-track-click='{"mod":"kp_popu_65-1061","con":",,"}' data-report-view='{"mod":"kp_popu_65-1061","keyword":""}' data-report-click='{"mod":"kp_popu_65-1061","keyword":""}'><iframe  src="https://kunpeng-sc.csdnimg.cn/#/preview/236?positionId=65&queryWord=" frameborder="0" width= "100%"  height= "75px" scrolling="no" ></iframe></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sinat_38301574/article/details/80139117","strategy":"BlogCommendFromBaidu","index":"34"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sinat_38301574/article/details/80139117","strategy":"BlogCommendFromBaidu","index":"34"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sinat_38301574/article/details/80139117" target="_blank" title="mysql使用命令行运行.sql脚本">
		<h4 class="text-truncate oneline">
				<em>mysql</em>使用命令行运行.<em>sql</em>脚本		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-28</span>
				<span class="read-num hover-hide">
					阅读数 
					311</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sinat_38301574/article/details/80139117" target="_blank" title="mysql使用命令行运行.sql脚本">
				<span class="desc oneline">在已连接数据库的情况下：sourcee:\create.sqlcreate.sql放在e盘根目录下。</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sinat_38301574">来自：	<span class="blog_title"> sinat_38301574的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/linshenshijianlu/article/details/78321078","strategy":"BlogCommendFromBaidu","index":"35"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/linshenshijianlu/article/details/78321078","strategy":"BlogCommendFromBaidu","index":"35"}'>
	<div class="content">
		<a href="https://blog.csdn.net/linshenshijianlu/article/details/78321078" target="_blank" title="命令行执行SQL语句">
		<h4 class="text-truncate oneline">
				命令行<em>执行</em><em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-23</span>
				<span class="read-num hover-hide">
					阅读数 
					5381</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/linshenshijianlu/article/details/78321078" target="_blank" title="命令行执行SQL语句">
				<span class="desc oneline">由于之前一直使用可视化界面执行SQL语句，对于命令行执行SQL语句比较陌生，所以，今天尝试了一下，并记录下来，与大家分享；    一、win+r进入doc窗口；   二、找到你电脑里的mysqlser...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/linshenshijianlu">来自：	<span class="blog_title"> linshenshijianlu的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/hwhua1986/article/details/53468540","strategy":"BlogCommendFromBaidu","index":"36"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/hwhua1986/article/details/53468540","strategy":"BlogCommendFromBaidu","index":"36"}'>
	<div class="content">
		<a href="https://blog.csdn.net/hwhua1986/article/details/53468540" target="_blank" title="mysql:在命令行执行sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>:在命令行<em>执行</em><em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">12-05</span>
				<span class="read-num hover-hide">
					阅读数 
					1619</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/hwhua1986/article/details/53468540" target="_blank" title="mysql:在命令行执行sql语句">
				<span class="desc oneline">首先进入mysql命令行登录mysql-uroot-p123456(mysql-u用户名-p用户名密码，如果有端口就带-P端口号)其次，选择数据库use数据库名：如usetest;最后就行执行sql：...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/hwhua1986">来自：	<span class="blog_title"> 测试蜗牛，一步一个脚印</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/stargeng625/article/details/78337343","strategy":"BlogCommendFromBaidu","index":"37"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/stargeng625/article/details/78337343","strategy":"BlogCommendFromBaidu","index":"37"}'>
	<div class="content">
		<a href="https://blog.csdn.net/stargeng625/article/details/78337343" target="_blank" title="在MySQL命令行窗口执行sql脚本，批量执行SQL语句，批量更新数据">
		<h4 class="text-truncate oneline">
				在<em>MySQL</em>命令行窗口<em>执行</em><em>sql</em>脚本，批量<em>执行</em><em>SQL</em><em>语句</em>，批量更新数据		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-25</span>
				<span class="read-num hover-hide">
					阅读数 
					4371</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/stargeng625/article/details/78337343" target="_blank" title="在MySQL命令行窗口执行sql脚本，批量执行SQL语句，批量更新数据">
				<span class="desc oneline">例如mysqltest.sql脚本在D盘根目录，进入MySQL的命令行窗口，直接输入如下命令即可批量执行脚本中的sql语句：sourceD:\mysqltest.sql注：结尾不带分号执行。...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/stargeng625">来自：	<span class="blog_title"> stargeng625的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_31598113/article/details/79887960","strategy":"BlogCommendFromBaidu","index":"38"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_31598113/article/details/79887960","strategy":"BlogCommendFromBaidu","index":"38"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_31598113/article/details/79887960" target="_blank" title="在shell脚本中登录Mysql并执行SQL语句">
		<h4 class="text-truncate oneline">
				在shell脚本中登录<em>Mysql</em>并<em>执行</em><em>SQL</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">04-10</span>
				<span class="read-num hover-hide">
					阅读数 
					1万+</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_31598113/article/details/79887960" target="_blank" title="在shell脚本中登录Mysql并执行SQL语句">
				<span class="desc oneline">有一个需求是，自动删除MYSQL中的过期数据，只保留最近一周的数据。在shell脚本中登录Mysql并执行SQL语句，示例代码如下：#!/bin/bashecho&amp;amp;amp;amp;quot;0...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_31598113">来自：	<span class="blog_title"> Tony_仔仔 的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_66" data-pid="66" data-track-view='{"mod":"kp_popu_66-87","con":",,"}' data-track-click='{"mod":"kp_popu_66-87","con":",,"}' data-report-view='{"mod":"kp_popu_66-87","keyword":""}' data-report-click='{"mod":"kp_popu_66-87","keyword":""}'><div id="three_ad38" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 852,
                h : 60,
                showid : 'Afihld',
                placeholderId: "three_ad38",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 18,
                    titleFontColor: '#000',
                    titleFontFamily : 'Lato,-apple-system,SF UI Text,Arial,PingFang SC,Hiragino Sans GB,Microsoft YaHei,WenQuanYi Micro Hei,sans-serif',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 0,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box recommend-box-ident recommend-other-item-box" data-report-view='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392408287","strategy":"BlogCommendFromBaidu","index":"39"}' data-report-click='{"mod":"popu_614","dest":"https://bbs.csdn.net/topics/392408287","strategy":"BlogCommendFromBaidu","index":"39"}'>
	<a href="https://bbs.csdn.net/topics/392408287" target="_blank">
		<h4 class="text-truncate oneline">
				请教：是不是一个进程不能同时<em>执行</em>多个<em>sql</em>命令（不管用几个<em>mysql</em>连接）		</h4>
		<div class="info-box d-flex align-content-center">
				<span class="date">07-02</span>
		</div>
		<p class="content oneline">
			<span class="desc oneline">大家好，请教一个问题，是不是一个进程不能同时执行多个sql命令（不管用几个mysql连接）？ 我的程序（windows端）开了两个线程，每个线程都单独一个mysql连接，单独的数据集，对不同的表进行查</span>
							<span class="type-show type-show-bbs">论坛</span>
					</p>
	</a>

</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_41672800/article/details/82419153","strategy":"BlogCommendFromBaidu","index":"40"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/qq_41672800/article/details/82419153","strategy":"BlogCommendFromBaidu","index":"40"}'>
	<div class="content">
		<a href="https://blog.csdn.net/qq_41672800/article/details/82419153" target="_blank" title="mysql交互式外部执行sql语句">
		<h4 class="text-truncate oneline">
				<em>mysql</em>交互式外部<em>执行</em><em>sql</em><em>语句</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-05</span>
				<span class="read-num hover-hide">
					阅读数 
					808</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/qq_41672800/article/details/82419153" target="_blank" title="mysql交互式外部执行sql语句">
				<span class="desc oneline">再mysql交互式模式外部执行sql语句使用-N-e参数-N意思是不显示结果的行号-e是执行sql语句注:不要忘记写database,因为进行表操作要先选择数据库示例:mysql-u-pdatabas...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/qq_41672800">来自：	<span class="blog_title"> qq_41672800的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/jiht594/article/details/8079146","strategy":"BlogCommendFromBaidu","index":"41"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/jiht594/article/details/8079146","strategy":"BlogCommendFromBaidu","index":"41"}'>
	<div class="content">
		<a href="https://blog.csdn.net/jiht594/article/details/8079146" target="_blank" title="mysql下如何执行sql脚本">
		<h4 class="text-truncate oneline">
				<em>mysql</em>下如何<em>执行</em><em>sql</em>脚本		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">10-16</span>
				<span class="read-num hover-hide">
					阅读数 
					433</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/jiht594/article/details/8079146" target="_blank" title="mysql下如何执行sql脚本">
				<span class="desc oneline">首要步骤(一般可省略):开启mysql服务(默认是开机时就自动运行了):控制面板--&gt;管理工具--&gt;服务,在里面找到名称为mysql的项,双击就可看它的服务状态是启动还是停止,把它设为启动连接mysq...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/jiht594">来自：	<span class="blog_title"> jiht594的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/liu16659/article/details/86595891","strategy":"BlogCommendFromBaidu","index":"42"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liu16659/article/details/86595891","strategy":"BlogCommendFromBaidu","index":"42"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liu16659/article/details/86595891" target="_blank" title="在 mysql 中执行系统命令">
		<h4 class="text-truncate oneline">
				在 <em>mysql</em> 中<em>执行</em>系统命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-22</span>
				<span class="read-num hover-hide">
					阅读数 
					1986</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liu16659/article/details/86595891" target="_blank" title="在 mysql 中执行系统命令">
				<span class="desc oneline">在mysql中执行系统命令1.需求如何在mysql的命令行界面操作底层系统呢？只需要在mysql命令行界面使用system+linux命令即可。2.命令2.1查看当前文件下的文件mysql&amp;amp;g...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liu16659">来自：	<span class="blog_title"> LittleLawson的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/u012885438/article/details/73930230","strategy":"BlogCommendFromBaidu","index":"43"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/u012885438/article/details/73930230","strategy":"BlogCommendFromBaidu","index":"43"}'>
	<div class="content">
		<a href="https://blog.csdn.net/u012885438/article/details/73930230" target="_blank" title="mysql 执行命令">
		<h4 class="text-truncate oneline">
				<em>mysql</em> <em>执行</em>命令		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-30</span>
				<span class="read-num hover-hide">
					阅读数 
					339</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/u012885438/article/details/73930230" target="_blank" title="mysql 执行命令">
				<span class="desc oneline">/*启动MySQL*/netstartmysql/*连接与断开服务器*/mysql-h地址-P端口-u用户名-p密码/*跳过权限验证登录MySQL*/mysqld--skip-grant-tables...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/u012885438">来自：	<span class="blog_title"> 平凡中不平凡</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_67" data-pid="67" data-track-view='{"mod":"kp_popu_67-658","con":",,"}' data-track-click='{"mod":"kp_popu_67-658","con":",,"}' data-report-view='{"mod":"kp_popu_67-658","keyword":""}' data-report-click='{"mod":"kp_popu_67-658","keyword":""}'><script type="text/javascript">
    (function() {
        var s = "_" + Math.random().toString(36).slice(2);
        document.write('<div style="" id="' + s + '"></div>');
        (window.slotbydup = window.slotbydup || []).push({
            id: "u3573058",
            container:  s
        });
    })();
</script>
<!-- 多条广告如下脚本只需引入一次 -->
<script type="text/javascript" src="//cpro.baidustatic.com/cpro/ui/c.js" async="async" defer="defer" ></script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/blank_bird/article/details/6741282","strategy":"BlogCommendFromBaidu","index":"44"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/blank_bird/article/details/6741282","strategy":"BlogCommendFromBaidu","index":"44"}'>
	<div class="content">
		<a href="https://blog.csdn.net/blank_bird/article/details/6741282" target="_blank" title="在命令行上直接运行mysql文件">
		<h4 class="text-truncate oneline">
				在命令行上直接运行<em>mysql</em>文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-01</span>
				<span class="read-num hover-hide">
					阅读数 
					2341</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/blank_bird/article/details/6741282" target="_blank" title="在命令行上直接运行mysql文件">
				<span class="desc oneline">注意这里是在bash中，，windows下当然不可以这样玩法。。不过可以尝试写个bat批处理文件达到同样效果！要运行mysql文件，如果已经登录mysql，在mysql命令行中则可以直接运行：sour...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/blank_bird">来自：	<span class="blog_title"> blank_bird的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/sully2008/article/details/86765672","strategy":"BlogCommendFromBaidu","index":"45"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/sully2008/article/details/86765672","strategy":"BlogCommendFromBaidu","index":"45"}'>
	<div class="content">
		<a href="https://blog.csdn.net/sully2008/article/details/86765672" target="_blank" title="mysql命令行执行sql脚本文件">
		<h4 class="text-truncate oneline">
				<em>mysql</em>命令行<em>执行</em><em>sql</em>脚本文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">02-05</span>
				<span class="read-num hover-hide">
					阅读数 
					672</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/sully2008/article/details/86765672" target="_blank" title="mysql命令行执行sql脚本文件">
				<span class="desc oneline">在win7的Dos窗口使用mysql命令行的方式执行sql脚本文件，建议在系统变量中配置mysql的bin路径，这样在Dos窗口的任何目录都可以执行mysql命令。1.进入Dos窗口，执行如下的命令-...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/sully2008">来自：	<span class="blog_title"> sully2008的专栏</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/ming_xiaoxiami/article/details/81905388","strategy":"BlogCommendFromBaidu","index":"46"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/ming_xiaoxiami/article/details/81905388","strategy":"BlogCommendFromBaidu","index":"46"}'>
	<div class="content">
		<a href="https://blog.csdn.net/ming_xiaoxiami/article/details/81905388" target="_blank" title="centos mysql 命令行下执行 sql 文件">
		<h4 class="text-truncate oneline">
				centos <em>mysql</em> 命令行下<em>执行</em> <em>sql</em> 文件		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">08-21</span>
				<span class="read-num hover-hide">
					阅读数 
					1799</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/ming_xiaoxiami/article/details/81905388" target="_blank" title="centos mysql 命令行下执行 sql 文件">
				<span class="desc oneline">命令行下执行sql文件有两种方法一、第一中方法(未连接数据库)不推荐这样使用因为在密码带有特殊字符时会报错mysql-hlocalhost-uusername-ppassword&amp;amp;amp;am...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/ming_xiaoxiami">来自：	<span class="blog_title"> ming_xiaoxiami的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangzhao100110/article/details/84696179","strategy":"BlogCommendFromBaidu","index":"47"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/zhangzhao100110/article/details/84696179","strategy":"BlogCommendFromBaidu","index":"47"}'>
	<div class="content">
		<a href="https://blog.csdn.net/zhangzhao100110/article/details/84696179" target="_blank" title="linux shell命令执行sql(mysql入门)">
		<h4 class="text-truncate oneline">
				linux shell命令<em>执行</em><em>sql</em>(<em>mysql</em>入门)		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">01-14</span>
				<span class="read-num hover-hide">
					阅读数 
					170</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/zhangzhao100110/article/details/84696179" target="_blank" title="linux shell命令执行sql(mysql入门)">
				<span class="desc oneline">    今天做个linux下的shell操作数据库的入门例子    1.shell文件内容：     #!/bin/bashHOSTNAME=&amp;quot;11.8.8.87&amp;quot;PORT=&amp;qu...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/zhangzhao100110">来自：	<span class="blog_title"> zeromike</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_40569991/article/details/80653194","strategy":"BlogCommendFromBaidu","index":"48"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/weixin_40569991/article/details/80653194","strategy":"BlogCommendFromBaidu","index":"48"}'>
	<div class="content">
		<a href="https://blog.csdn.net/weixin_40569991/article/details/80653194" target="_blank" title="mysql命令行写sql">
		<h4 class="text-truncate oneline">
				<em>mysql</em>命令行写<em>sql</em>		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">06-11</span>
				<span class="read-num hover-hide">
					阅读数 
					294</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/weixin_40569991/article/details/80653194" target="_blank" title="mysql命令行写sql">
				<span class="desc oneline">开启mysql:netstatmysql1.命令mysql-uroot-p2.进入mysql</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/weixin_40569991">来自：	<span class="blog_title"> Shirley的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	<div class="recommend-item-box recommend-ad-box"><div id="kp_box_68" data-pid="68" data-track-view='{"mod":"kp_popu_68-654","con":",,"}' data-track-click='{"mod":"kp_popu_68-654","con":",,"}' data-report-view='{"mod":"kp_popu_68-654","keyword":""}' data-report-click='{"mod":"kp_popu_68-654","keyword":""}'><div id="three_ad48" class="mediav_ad" ></div>
<script>
                                               NEWS_FEED({
                w: 900,
                h : 84,
                showid : 'Afihld',
                placeholderId: "three_ad48",
                inject : 'define',
                define : {
                    imagePosition : 'left',
                    imageBorderRadius : 3,
                    imageWidth: 90,
                    imageHeight: 60,
                    imageFill : 'clip',
                    displayImage : true,
                    displayTitle : true,
                    titleFontSize: 16,
                    titleFontColor: '#000',
                    titleFontFamily : 'Microsoft Yahei',
                    titleFontWeight: 'bold',
                    titlePaddingTop : 0,
                    titlePaddingRight : 0,
                    titlePaddingBottom : 5,
                    titlePaddingLeft : 16,
                    displayDesc : true,
                    descFontSize: 14,
                    descFontColor: '#8e959a',
                    descFontFamily : 'Microsoft Yahei',
                    paddingTop : 10,
                    paddingRight : 0,
                    paddingBottom : 0,
                    paddingLeft : 0,
                    backgroundColor: '#fff',
                    hoverColor: '#000'
                      }
                  })
                                        </script></div></div>
	
<div class="recommend-item-box type_blog clearfix" data-report-view='{"mod":"popu_614","dest":"https://blog.csdn.net/liyaohui_szz/article/details/82862376","strategy":"BlogCommendFromBaidu","index":"49"}' data-report-click='{"mod":"popu_614","dest":"https://blog.csdn.net/liyaohui_szz/article/details/82862376","strategy":"BlogCommendFromBaidu","index":"49"}'>
	<div class="content">
		<a href="https://blog.csdn.net/liyaohui_szz/article/details/82862376" target="_blank" title="MYSQL命令行导入sql脚本">
		<h4 class="text-truncate oneline">
				<em>MYSQL</em>命令行导入<em>sql</em>脚本		</h4>
		<div class="info-box d-flex align-content-center">
			<p class="date-and-readNum oneline">
				<span class="date hover-show">09-27</span>
				<span class="read-num hover-hide">
					阅读数 
					1027</span>
				</p>
			</div>
		</a>
		<p class="content">
			<a href="https://blog.csdn.net/liyaohui_szz/article/details/82862376" target="_blank" title="MYSQL命令行导入sql脚本">
				<span class="desc oneline">//进入数据库MySQL-uroot-ppasswd//选择数据库user数据库名称//导入数据库脚本sourceC:/xxx.sql ...</span>
			</a>
			<span class="blog_title_box oneline ">
									<span class="type-show type-show-blog type-show-after">博文</span>
											<a target="_blank" href="https://blog.csdn.net/liyaohui_szz">来自：	<span class="blog_title"> 李耀辉的博客</span></a>
												</span>
		</p>
	</div>
	</div>

	
	
                <div class="recommend-item-box type_hot_word">
                                <div class="content clearfix">
                    <div class="word float-left">
                                                            <span>
                        <a href="https://edu.csdn.net/courses/o5329_s5330_k " target="_blank">
                        机器学习教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/courses/o280_s351_k " target="_blank">
                        Objective-C培训                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o7115_s388_l0_t " target="_blank">
                        交互设计视频教程                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/course/play/5599/104252 " target="_blank">
                        颜色模型                    </a></span>
                                                                                <span>
                        <a href="https://edu.csdn.net/combos/o363_l0_t " target="_blank">
                        设计制作学习                    </a></span>
                                                            </div>
                </div>
                                                <div class="content clearfix">
                    <div class="float-left">
                                        <span>
                        <a href="https://www.csdn.net/gather_24/MtTaEg3sMDM5MS1ibG9n.html" target="_blank">
                        mysql关联查询两次本表</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_10/MtjaIg3sMTUzMy1kb3dubG9hZAO0O0OO0O0O.html" target="_blank">
                        native底部 react</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_1b/Ntzagg1sOTU3LWRvd25sb2Fk.html" target="_blank">
                        extjs glyph 图标</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/MtzakgxsMDQtZWR1.html" target="_blank">
                        nlp执行师教程</a>
                    </span>
                                        <span>
                        <a href="https://www.csdn.net/gather_4a/Mtzakg2sOTItZWR1.html" target="_blank">
                        nlp执行师价格</a>
                    </span>
                                        </div>
                </div>
                                </div>
                            <div class="recommend-loading-box">
                <img src='https://csdnimg.cn/release/phoenix/images/feedLoading.gif'>
            </div>
            <div class="recommend-end-box">
                <p class="text-center">没有更多推荐了，<a href="https://blog.csdn.net/" class="c-blue c-blue-hover c-blue-focus">返回首页</a></p>
            </div>
        </div>
    </main>

    <aside>
	<div id="asideProfile" class="aside-box">
    <!-- <h3 class="aside-title">个人资料</h3> -->
    <div class="profile-intro d-flex">
        <div class="avatar-box d-flex justify-content-center flex-column">
            <a href="https://blog.csdn.net/sinat_36246371">
              <img src="https://avatar.csdn.net/E/4/5/3_sinat_36246371.jpg" class="avatar_pic">
                              <img src="https://g.csdnimg.cn/static/user-reg-year/1x/3.png" class="user-years">
                          </a>
            
        </div>
        <div class="user-info d-flex justify-content-center flex-column">
            <p class="name csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                <a href="https://blog.csdn.net/sinat_36246371"  class="" id="uid">K.Sun</a>
            </p>
                    </div>
                <div class="opt-box d-flex justify-content-center flex-column">
            <span  class="csdn-tracking-statistics tracking-click" data-report-click='{"mod":"popu_379"}'>
                                    <a class="btn btn-sm btn-red-hollow attention" id="btnAttent">关注</a>
                            </span>
        </div>
            </div>
    <div class="data-info d-flex item-tiling">
                <dl class="text-center" title="263">
                        <dt><a href="https://blog.csdn.net/sinat_36246371?t=1">原创</a></dt>
            <dd><a href="https://blog.csdn.net/sinat_36246371?t=1"><span class="count">263</span></a></dd>
                    </dl>
        <dl class="text-center" id="fanBox" title="105">
            <dt>粉丝</dt>
            <dd><span class="count" id="fan">105</span></dd>
        </dl>
        <dl class="text-center" title="140">
            <dt>喜欢</dt>
            <dd><span class="count">140</span></dd>
        </dl>
        <dl class="text-center" title="67">
            <dt>评论</dt>
            <dd><span class="count">67</span></dd>
        </dl>
    </div>
    <div class="grade-box clearfix">
        <dl>
            <dt>等级：</dt>
            <dd>
                <a href="https://blog.csdn.net/home/help.html#level" title="6级,点击查看等级说明" target="_blank">
                    <svg class="icon icon-level" aria-hidden="true">
                        <use xlink:href="#csdnc-bloglevel-6"></use>
                    </svg>
                </a>
            </dd>
        </dl>
        <dl>
            <dt>访问：</dt>
            <dd title="800660">
                80万+            </dd>
        </dl>
        <dl>
            <dt>积分：</dt>
            <dd title="9444">
                9444            </dd>
        </dl>
        <dl title="3519">
            <dt>排名：</dt>
            <dd>3519</dd>
        </dl>
    </div>
        <div class="badge-box d-flex">
        <span>勋章：</span>
        <div class="badge d-flex">
                                                        <div class="icon-badge" title="勤写标兵Lv1">
                       <div class="mouse-box">
                          <img src="https://g.csdnimg.cn/static/user-medal/qinxiebiaobing_l1_t1.svg" alt="">
                          <div class="icon-arrow"></div>
                       </div>
                       <div class="grade-detail-box">
                           <div class="pos-box">
                               <div class="left-box d-flex justify-content-center align-items-center flex-column">
                                    <img src="https://g.csdnimg.cn/static/user-medal/qinxiebiaobing_l1_t1.svg" alt="">
                                   <p>勤写标兵Lv1</p>
                               </div>
                               <div class="right-box">
                                   授予每个自然周发布1篇到3篇原创IT博文的用户。本勋章将于次周周三上午根据用户上周的博文发布情况由系统自动颁发。                               </div>
                           </div>
                       </div>
                   </div>
                                             </div>
        <script>
            (function ($) {
                setTimeout(function(){
                    $('div.icon-badge.show-moment').removeClass('show-moment');
                }, 5000);
            })(window.jQuery)
        </script>
    </div>
        <div class="personal-home-page"><a target="_blank"  href="https://me.csdn.net/sinat_36246371">TA的个人主页 ></a></div>
</div>
<div class="csdn-tracking-statistics mb8 box-shadow" data-pid="blog" data-report-click='{"mod":"popu_4"}' data-report-view='{"mod":"popu_4"}' style="height:250px;">
    <div class="aside-content text-center" id="cpro_u2734133">
      <div id="kp_box_56" data-pid="56" data-track-view='{"mod":"kp_popu_56-703","con":",,"}' data-track-click='{"mod":"kp_popu_56-703","con":",,"}' data-report-view='{"mod":"kp_popu_56-703","keyword":""}' data-report-click='{"mod":"kp_popu_56-703","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左上视窗-20181120 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="7700527946"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>    </div>
</div>
<div id="asideNewArticle" class="aside-box">
    <h3 class="aside-title">最新文章</h3>
    <div class="aside-content">
        <ul class="inf_list clearfix csdn-tracking-statistics tracking-click" data-mod="popu_382">
                        <li class="clearfix">
                <a href="https://blog.csdn.net/sinat_36246371/article/details/94621109" target="_blank" >
                                        npm生成的package.json文件中依赖项版本号前的波浪号(~)和插入符号(^)是啥意思？                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/sinat_36246371/article/details/93644135" target="_blank" >
                                        推荐几个关于学习编程的GitHub仓库                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/sinat_36246371/article/details/93610581" target="_blank" >
                                        开发人员必备的13项技能                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/sinat_36246371/article/details/88839133" target="_blank" >
                                        Git：重新提交没有更新的commit                </a>
            </li>
                        <li class="clearfix">
                <a href="https://blog.csdn.net/sinat_36246371/article/details/88796320" target="_blank" >
                                        JavaScript中Number类下几个常见的方法                </a>
            </li>
                    </ul>
    </div>
</div>
<div id="asideCategory" class="aside-box flexible-box">
    <h3 class="aside-title">个人分类</h3>
    <div class="aside-content">
        <ul>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456337">
                    <span class="title oneline">Algorithm</span>
                    <span class="count float-right">138篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6460321">
                    <span class="title oneline">Dynamic Programming</span>
                    <span class="count float-right">15篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456362">
                    <span class="title oneline">Java</span>
                    <span class="count float-right">49篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456363">
                    <span class="title oneline">C++</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456365">
                    <span class="title oneline">Tomcat</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456364">
                    <span class="title oneline">Eclipse</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456368">
                    <span class="title oneline">Google</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456373">
                    <span class="title oneline">IntelliJ IDEA</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456375">
                    <span class="title oneline">MySQL</span>
                    <span class="count float-right">14篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456374">
                    <span class="title oneline">Microsoft Visual Studio</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456418">
                    <span class="title oneline">Leetcode</span>
                    <span class="count float-right">112篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456376">
                    <span class="title oneline">SQL</span>
                    <span class="count float-right">8篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456379">
                    <span class="title oneline">Interview</span>
                    <span class="count float-right">22篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456380">
                    <span class="title oneline">JavaScript</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6456384">
                    <span class="title oneline">Spring</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6460081">
                    <span class="title oneline">Array</span>
                    <span class="count float-right">13篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6460306">
                    <span class="title oneline">Multi-Thread</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6460308">
                    <span class="title oneline">Container</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6460645">
                    <span class="title oneline">geeksforgeeks</span>
                    <span class="count float-right">12篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461514">
                    <span class="title oneline">Tree</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461515">
                    <span class="title oneline">Data Structure</span>
                    <span class="count float-right">49篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461516">
                    <span class="title oneline">Graph</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461790">
                    <span class="title oneline">Sort</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461797">
                    <span class="title oneline">DataBase</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461828">
                    <span class="title oneline">OS</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461831">
                    <span class="title oneline">Linux</span>
                    <span class="count float-right">18篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461832">
                    <span class="title oneline">Computer Network</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461855">
                    <span class="title oneline">GitHub</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461872">
                    <span class="title oneline">Python</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6461874">
                    <span class="title oneline">Design Pattern</span>
                    <span class="count float-right">9篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6464169">
                    <span class="title oneline">String</span>
                    <span class="count float-right">20篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6464175">
                    <span class="title oneline">Vim</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6464195">
                    <span class="title oneline">Ubuntu</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6464895">
                    <span class="title oneline">Amazon</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6466850">
                    <span class="title oneline">JVM</span>
                    <span class="count float-right">19篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6487944">
                    <span class="title oneline">Android</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6498759">
                    <span class="title oneline">GC</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6499722">
                    <span class="title oneline">Shell</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6501670">
                    <span class="title oneline">sed</span>
                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6506375">
                    <span class="title oneline">OpenCV</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6727698">
                    <span class="title oneline">C</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6727699">
                    <span class="title oneline">EMC</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6728208">
                    <span class="title oneline">PyCharm</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6728284">
                    <span class="title oneline">HTTP</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6730832">
                    <span class="title oneline">Machine Learning</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6730833">
                    <span class="title oneline">AI</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6730835">
                    <span class="title oneline">Digital Image Processing</span>
                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6737597">
                    <span class="title oneline">MyBatis</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6745652">
                    <span class="title oneline">Search</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6796315">
                    <span class="title oneline">nodejs</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6826846">
                    <span class="title oneline">spring-boot</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6844329">
                    <span class="title oneline">git</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6861818">
                    <span class="title oneline">Maven</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6886768">
                    <span class="title oneline">jdk1-8</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6912831">
                    <span class="title oneline">二叉树</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6928843">
                    <span class="title oneline">Kotlin</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6960464">
                    <span class="title oneline">Sping</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6961583">
                    <span class="title oneline">Big-Data</span>
                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/6961584">
                    <span class="title oneline">MapReduce</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7008602">
                    <span class="title oneline">SOAP</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7008603">
                    <span class="title oneline">RESTful</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7008606">
                    <span class="title oneline">Web Service</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7010548">
                    <span class="title oneline">Hadoop</span>
                    <span class="count float-right">10篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7010598">
                    <span class="title oneline">Data</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7011151">
                    <span class="title oneline">HBase</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7011552">
                    <span class="title oneline">Cache</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7208370">
                    <span class="title oneline">负载均衡算法</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7208371">
                    <span class="title oneline">面试</span>
                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7208443">
                    <span class="title oneline">分布式系统</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7208497">
                    <span class="title oneline">Threadpool</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7211119">
                    <span class="title oneline">Redis</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7485983">
                    <span class="title oneline">Mac</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7489357">
                    <span class="title oneline">Rails</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/7729203">
                    <span class="title oneline">Microservice</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/8556085">
                    <span class="title oneline">Management</span>
                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/9088349">
                    <span class="title oneline">npm</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <li>
                <a class="clearfix" href="https://blog.csdn.net/sinat_36246371/article/category/9088350">
                    <span class="title oneline">node</span>
                    <span class="count float-right">1篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideArchive" class="aside-box flexible-box">
    <h3 class="aside-title">归档</h3>
    <div class="aside-content">
        <ul class="archive-list">
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2019/07">
                    2019年7月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2019/06">
                    2019年6月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2019/03">
                    2019年3月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/12">
                    2018年12月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/10">
                    2018年10月                    <span class="count float-right">1篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/06">
                    2018年6月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/04">
                    2018年4月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/03">
                    2018年3月                    <span class="count float-right">4篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/02">
                    2018年2月                    <span class="count float-right">2篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2018/01">
                    2018年1月                    <span class="count float-right">7篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/12">
                    2017年12月                    <span class="count float-right">5篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/11">
                    2017年11月                    <span class="count float-right">3篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/10">
                    2017年10月                    <span class="count float-right">16篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/07">
                    2017年7月                    <span class="count float-right">19篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/06">
                    2017年6月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/05">
                    2017年5月                    <span class="count float-right">23篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/04">
                    2017年4月                    <span class="count float-right">6篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/03">
                    2017年3月                    <span class="count float-right">17篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/02">
                    2017年2月                    <span class="count float-right">31篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2017/01">
                    2017年1月                    <span class="count float-right">35篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2016/12">
                    2016年12月                    <span class="count float-right">75篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2016/11">
                    2016年11月                    <span class="count float-right">55篇</span>
                </a>
            </li>
                        <!--归档统计-->
            <li>
                <a href="https://blog.csdn.net/sinat_36246371/article/month/2016/10">
                    2016年10月                    <span class="count float-right">48篇</span>
                </a>
            </li>
                    </ul>
    </div>
        <p class="text-center">
        <a class="btn btn-link-blue flexible-btn" data-fbox="aside-archive">展开</a>
    </p>
    </div>
<div id="asideNewComments" class="aside-box">
    <h3 class="aside-title">最新评论</h3>
    <div class="aside-content">
        <ul class="newcomment-list">
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/sinat_36246371/article/details/74388711#comments">Java中的Main线程</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_37877854" class="user-name" target="_blank">qq_37877854：</a>锁都没有也能被称作死锁，太高端了                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/sinat_36246371/article/details/79738782#comments">Git: There is no ...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/LZXweb" class="user-name" target="_blank">LZXweb：</a>优秀    感谢                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/sinat_36246371/article/details/54581185#comments">SQL替换NULL值的显示</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qq_45287704" class="user-name" target="_blank">qq_45287704：</a>太棒了，刚好解决我另外的一个问题！                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/sinat_36246371/article/details/53425183#comments">MySQL利用多核处理器</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/qsmxtjy" class="user-name" target="_blank">qsmxtjy：</a>大佬, &amp;lt;&lt;High&gt;&gt;中说MySQL无法利用多核特性来执行并行查询, 这句改怎么解读呢?                </p>
            </li>
                        <li>
                <a class="title text-truncate" target="_blank" href="https://blog.csdn.net/sinat_36246371/article/details/52914448#comments">用Intellij Idea从Gi...</a>
                <p class="comment ellipsis">
                    <a href="https://my.csdn.net/codesweetpotato" class="user-name" target="_blank">codesweetpotato：</a>楼主,如何自动导入jar包和依赖.下载之后,没有pom文件                </p>
            </li>
                    </ul>
    </div>
</div>
	<div id="asideFooter">
			
		<div class="aside-box">
			<div id="kp_box_57" data-pid="57" data-track-view='{"mod":"kp_popu_57-707","con":",,"}' data-track-click='{"mod":"kp_popu_57-707","con":",,"}' data-report-view='{"mod":"kp_popu_57-707","keyword":""}' data-report-click='{"mod":"kp_popu_57-707","keyword":""}'><script async src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>
<!-- 博客内页左下视窗-20181130 -->
<ins class="adsbygoogle"
     style="display:inline-block;width:300px;height:250px"
     data-ad-client="ca-pub-1076724771190722"
     data-ad-slot="1894159733"></ins>
<script>
(adsbygoogle = window.adsbygoogle || []).push({});
</script></div>		</div>
				<div class="aside-box">
			<div class="persion_article">
			</div>
		</div>
	</div>
</aside>
<script src="https://csdnimg.cn/pubfooter/js/publib_footer-1.0.3.js" data-isfootertrack="false" type="text/javascript"></script>
<script>
	$("a.flexible-btn").click(function(){
		$(this).parents('div.aside-box').removeClass('flexible-box');
		$(this).remove();
	})
</script>
</div>
<div class="mask-dark"></div>
<div class="tool-box vertical">
    	<ul class="meau-list">
		<li class="btn-like-box ">
			<button class=" low-height hover-box btn-like " title="点赞">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-thumbsup"></use>
				</svg>
				<span class="hover-show text-box text">
					<span class="no-active">点赞</span>
					<span class="active">取消点赞</span>
				</span>
				<p id="supportCount">0</p>
			</button>
		</li>
		<li class="to-commentBox">
						<a class="btn-comments low-height hover-box" title="写评论" href="#commentBox">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-comments"></use>
				</svg>
				<span class="hover-show text">评论</span>
				<p class="">
										</p>
			</a>
		</li>
		<li class="toc-container-box" id="liTocBox">
			<a class="btn-toc low-height hover-box btn-comments" title="目录">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-contents"></use>
				</svg>
				<span class="hover-show text">目录</span>
			</a>
			<div class="toc-container">
				<div class="pos-box">
					<div class="icon-arrow"></div>
					<div class="scroll-box">
						<div class="toc-box"></div>
					</div>
				</div>
				<div class="opt-box">
					<button class="btn-opt prev nomore" title="向上">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevronup"></use>
						</svg>
					</button>
					<button class="btn-opt next">
						<svg class="icon" aria-hidden="true">
							<use xlink:href="#csdnc-chevrondown"></use>
						</svg>
					</button>
				</div>
			</div>
		</li>
		<li>
			<a class="btn-bookmark low-height hover-box btn-comments" title="收藏">
				<svg class="icon active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark-ok"></use>
				</svg>
				<svg class="icon no-active hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-bookmark"></use>
				</svg>
					<span class="hover-show text">收藏</span>
				<!-- <span class="hover-show text-box text">
					<span class="no-active">收藏</span>
					<span class="active">取消收藏</span>
				</span> -->
			</a>
		</li>
		<li class="bdsharebuttonbox">
			<div class="weixin-qr btn-comments low-height hover-box" >
        <a href="#" class="bds_weixin clear-share-style" data-cmd="weixin" title="手机看"></a>
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-usephone"></use>
				</svg>
				<span class="hover-show text text3">
					手机看
				</span>
			</div>
		</li>
							<li class="widescreen-hide">
				<a class="prev btn-comments low-height hover-box" href="https://blog.csdn.net/sinat_36246371/article/details/72648662" title="使用MySQL帮助">
					<svg class="icon hover-hide" aria-hidden="true">
						<use xlink:href="#csdnc-chevronleft"></use>
					</svg>
					<span class="hover-show text text3">上一篇</span>
				</a>
			</li>
								<li class="widescreen-hide">
			<a class="next btn-comments hover-box low-height" href="https://blog.csdn.net/sinat_36246371/article/details/72676951" title="MySQL中decimal与float的区别">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-chevronright"></use>
				</svg>
				<span class="hover-show text text3">下一篇</span>
			</a>
		</li>
						<!-- 宽屏更多按钮 -->
		<li class="widescreen-more">
			<a class="btn-comments chat-ask-button low-height hover-box" title="快问" href="#chatqa">
				<svg class="icon hover-hide" aria-hidden="true">
					<use xlink:href="#csdnc-more"></use>
				</svg>
				<span class="hover-show text">更多</span>
				
			</a>
			<ul class="widescreen-more-box">
													<li class="widescreen-more">
						<a class="btn-comments low-height hover-box" href="https://blog.csdn.net/sinat_36246371/article/details/72648662" title="使用MySQL帮助">
							<svg class="icon hover-hide" aria-hidden="true">
								<use xlink:href="#csdnc-chevronleft"></use>
							</svg>
							<span class="hover-show text text3">上一篇</span>
						</a>
					</li>
																<li class="widescreen-more">
					<a class="btn-comments hover-box low-height" href="https://blog.csdn.net/sinat_36246371/article/details/72676951" title="MySQL中decimal与float的区别">
						<svg class="icon hover-hide" aria-hidden="true">
							<use xlink:href="#csdnc-chevronright"></use>
						</svg>
						<span class="hover-show text text3">下一篇</span>
					</a>
				</li>
							</ul>
		</li>
	</ul>
</div>
<script>window._bd_share_config = { "common": { "bdSnsKey": {}, "bdText": "", "bdMini": "1", "bdMiniList": false, "bdPic": "", "bdStyle": "0", "bdSize": "16" }, "share": {} }; with (document) 0[(getElementsByTagName('head')[0] || body).appendChild(createElement('script')).src = 'https://csdnimg.cn/static/api/js/share.js?v=89860594'];</script>
<script src="https://g.csdnimg.cn/collection-box/1.0.0/collection-box.js?t=20190710173809" type="text/javascript"></script><script>
    var recommendCount = 50;
    recommendCount = recommendCount > 1 ? (recommendCount + (recommendCount>6 ? 2 : 1)) : recommendCount;
    var ChannelId = 6;
    var articleId = "72675736";
    var commentscount = 0;
    var islock = false;
    var curentUrl = "https://blog.csdn.net/sinat_36246371/article/details/72675736";
    var myUrl = "https://my.csdn.net/";
    //1禁止评论，2正常
    var commentAuth = 2;
    //百度搜索
    var baiduKey = "不登录到MySQL执行SQL语句 - K.Sun";
    var needInsertBaidu = true;
    // 代码段样式
    var codeStyle = 'atom-one-light';
	var highlight = ["\u5f55\u5230","mysql","\u6267\u884c","sql","\u8bed\u53e5"];//高亮数组

    var RecommendBlogExpertList = [];
	var articleType = 1;
	var CopyrightContent = '本文为博主原创文章，未经博主允许不得转载。';
</script>
<script src="https://csdnimg.cn/public/sandalstrap/1.4/js/sandalstrap.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/vendor/pagination/paging-3d3b805766.js"></script>


<div style="display:none;">
	<img src="" onerror='setTimeout(function(){if(!/(csdn.net|iteye.com|baiducontent.com|googleusercontent.com|360webcache.com|sogoucdn.com|bingj.com|baidu.com)$/.test(window.location.hostname)){window.location.href="\x68\x74\x74\x70\x73\x3a\x2f\x2f\x77\x77\x77\x2e\x63\x73\x64\x6e\x2e\x6e\x65\x74"}},3000);'>
</div>
</body>

	<link rel="stylesheet" href="https://csdnimg.cn/release/blog_editor_html/release1.4.3/ckeditor/plugins/codesnippet/lib/highlight/styles/atom-one-light.css">
	<script type="text/javascript" src="https://csdnimg.cn/release/phoenix/production/pc_wap_common-f868939e52.js" /></script>

<script src="https://csdnimg.cn/release/phoenix/template/js/common-37b7aadaf4.min.js"></script>
<script src="https://csdnimg.cn/release/phoenix/template/js/detail-1e5a65cde8.min.js"></script>

	<script src="https://csdnimg.cn/release/phoenix/themes/skin-yellow/skin-yellow-fc7383b956.min.js"></script>
<script>
 // 全局声明
 if (window.csdn === undefined) {
      window.csdn = {};
    }
    window.csdn.sideToolbar = {
        options: {
            report:{
                isShow: true,
            },
            afterFinished: function(){
                setTimeout(function () {
                    var viphtml = '<a class="option-box" data-type="vip" href="https://mall.csdn.net/vip" target="_blank">'+
                        '<img src="https://g.csdnimg.cn/side-toolbar/1.4/images/vip.png" alt="" srcset="">'+
                        '<span class="show-txt">VIP<br>免广告</span>'+
                        '</a>';
                    $('.csdn-side-toolbar').prepend(viphtml)
                },300)
            }
        }
    }

    $(function(){
        $(document).on('click',"a.option-box[data-type='report']",function() {
            showReport(false,articleTitles)
        });
    })
</script>
<script src="https://g.csdnimg.cn/side-toolbar/1.4/side-toolbar.js"></script>

    <script src="//g.csdnimg.cn/??login-box/1.0.6/login-box.js,login-box/1.0.7/login-auto.js,copyright/1.0.3/copyright.js,baidu-search/1.0.0/baidu-search.js?t=20190307095522"  type="text/javascript"></script>

<script type="text/javascript" src="https://csdnimg.cn/release/blog_mathjax/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
<script type="text/x-mathjax-config">
    MathJax.Hub.Config({
            "HTML-CSS": {
                    linebreaks: { automatic: true, width: "94%container" },
                    imageFont: null
            },
            tex2jax: {
                preview: "none"
            },
            mml2jax: {
                preview: 'none'
            }
    });
</script>
<script type="text/javascript">
    </script>
<script src="https://gh.bdstatic.com/static/gh/js/sdk/bword.min.js"></script>
</html>
